Pandas Profiling Report

Dataset statistics

Number of variables	31
Number of observations	88889
Missing cells	565032
Missing cells (%)	20.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	21.0 MiB
Average record size in memory	248.0 B

Variable types

Text	12
Categorical	9
DateTime	2
Unsupported	2
Boolean	1
Numeric	5

Alerts

`Aircraft.damage` is highly overall correlated with `Investigation.Type`	High correlation
`Engine.Type` is highly overall correlated with `Number.of.Engines` and 1 other fields	High correlation
`FAR.Description` is highly overall correlated with `Investigation.Type` and 1 other fields	High correlation
`Investigation.Type` is highly overall correlated with `Aircraft.damage` and 2 other fields	High correlation
`Number.of.Engines` is highly overall correlated with `Engine.Type` and 1 other fields	High correlation
`Purpose.of.flight` is highly overall correlated with `Schedule`	High correlation
`Schedule` is highly overall correlated with `Engine.Type` and 4 other fields	High correlation
`Total.Fatal.Injuries` is highly overall correlated with `Total.Uninjured`	High correlation
`Total.Uninjured` is highly overall correlated with `Total.Fatal.Injuries`	High correlation
`Investigation.Type` is highly imbalanced (74.2%)	Imbalance
`Aircraft.damage` is highly imbalanced (51.7%)	Imbalance
`Aircraft.Category` is highly imbalanced (79.3%)	Imbalance
`Amateur.Built` is highly imbalanced (54.6%)	Imbalance
`Engine.Type` is highly imbalanced (73.8%)	Imbalance
`FAR.Description` is highly imbalanced (55.2%)	Imbalance
`Purpose.of.flight` is highly imbalanced (54.1%)	Imbalance
`Weather.Condition` is highly imbalanced (76.0%)	Imbalance
`Latitude` has 54507 (61.3%) missing values	Missing
`Longitude` has 54516 (61.3%) missing values	Missing
`Airport.Code` has 38757 (43.6%) missing values	Missing
`Airport.Name` has 36185 (40.7%) missing values	Missing
`Injury.Severity` has 1000 (1.1%) missing values	Missing
`Aircraft.damage` has 3194 (3.6%) missing values	Missing
`Aircraft.Category` has 56602 (63.7%) missing values	Missing
`Registration.Number` has 1382 (1.6%) missing values	Missing
`Number.of.Engines` has 6084 (6.8%) missing values	Missing
`Engine.Type` has 7096 (8.0%) missing values	Missing
`FAR.Description` has 56866 (64.0%) missing values	Missing
`Schedule` has 76307 (85.8%) missing values	Missing
`Purpose.of.flight` has 6192 (7.0%) missing values	Missing
`Air.carrier` has 72241 (81.3%) missing values	Missing
`Total.Fatal.Injuries` has 11401 (12.8%) missing values	Missing
`Total.Serious.Injuries` has 12510 (14.1%) missing values	Missing
`Total.Minor.Injuries` has 11933 (13.4%) missing values	Missing
`Total.Uninjured` has 5912 (6.7%) missing values	Missing
`Weather.Condition` has 4492 (5.1%) missing values	Missing
`Broad.phase.of.flight` has 27165 (30.6%) missing values	Missing
`Report.Status` has 6384 (7.2%) missing values	Missing
`Publication.Date` has 13771 (15.5%) missing values	Missing
`Total.Fatal.Injuries` is highly skewed (γ1 = 33.01867532)	Skewed
`Total.Serious.Injuries` is highly skewed (γ1 = 49.40002485)	Skewed
`Total.Minor.Injuries` is highly skewed (γ1 = 87.26947645)	Skewed
`Latitude` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Longitude` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Number.of.Engines` has 1226 (1.4%) zeros	Zeros
`Total.Fatal.Injuries` has 59675 (67.1%) zeros	Zeros
`Total.Serious.Injuries` has 63289 (71.2%) zeros	Zeros
`Total.Minor.Injuries` has 61454 (69.1%) zeros	Zeros
`Total.Uninjured` has 29879 (33.6%) zeros	Zeros

Reproduction

Analysis started	2024-09-25 02:41:17.991759
Analysis finished	2024-09-25 02:41:25.039468
Duration	7.05 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

Event.Id
Text

Distinct	87951
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Memory size	694.6 KiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	1244446
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	87015 ?
Unique (%)	97.9%

Sample

1st row	20001218X45444
2nd row	20001218X45447
3rd row	20061025X01555
4th row	20001218X45448
5th row	20041105X01764

Value	Count	Frequency (%)
20001212x19172	3	< 0.1%
20001214x45071	3	< 0.1%
20001213x27982	2	< 0.1%
20001212x19398	2	< 0.1%
20001212x17181	2	< 0.1%
20001211x13231	2	< 0.1%
20041122x01848	2	< 0.1%
20070723x00975	2	< 0.1%
20001208x05272	2	< 0.1%
20001206x02750	2	< 0.1%
Other values (87941)	88867	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	348458	28.0%
2	229489	18.4%
1	206573	16.6%
X	85352	6.9%
3	73729	5.9%
4	66227	5.3%
5	50695	4.1%
7	47901	3.8%
8	46854	3.8%
9	44955	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1244446	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	348458	28.0%
2	229489	18.4%
1	206573	16.6%
X	85352	6.9%
3	73729	5.9%
4	66227	5.3%
5	50695	4.1%
7	47901	3.8%
8	46854	3.8%
9	44955	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1244446	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	348458	28.0%
2	229489	18.4%
1	206573	16.6%
X	85352	6.9%
3	73729	5.9%
4	66227	5.3%
5	50695	4.1%
7	47901	3.8%
8	46854	3.8%
9	44955	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1244446	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	348458	28.0%
2	229489	18.4%
1	206573	16.6%
X	85352	6.9%
3	73729	5.9%
4	66227	5.3%
5	50695	4.1%
7	47901	3.8%
8	46854	3.8%
9	44955	3.6%

Investigation.Type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	694.6 KiB

Accident	85015
Incident	3874

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	711112
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Accident
2nd row	Accident
3rd row	Accident
4th row	Accident
5th row	Accident

Common Values

Value	Count	Frequency (%)
Accident	85015	95.6%
Incident	3874	4.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
accident	85015	95.6%
incident	3874	4.4%

Most occurring characters

Value	Count	Frequency (%)
c	173904	24.5%
n	92763	13.0%
i	88889	12.5%
d	88889	12.5%
e	88889	12.5%
t	88889	12.5%
A	85015	12.0%
I	3874	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	711112	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
c	173904	24.5%
n	92763	13.0%
i	88889	12.5%
d	88889	12.5%
e	88889	12.5%
t	88889	12.5%
A	85015	12.0%
I	3874	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	711112	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
c	173904	24.5%
n	92763	13.0%
i	88889	12.5%
d	88889	12.5%
e	88889	12.5%
t	88889	12.5%
A	85015	12.0%
I	3874	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	711112	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
c	173904	24.5%
n	92763	13.0%
i	88889	12.5%
d	88889	12.5%
e	88889	12.5%
t	88889	12.5%
A	85015	12.0%
I	3874	0.5%

Accident.Number
Text

Distinct	88863
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	694.6 KiB

Length

Max length	11
Median length	10
Mean length	10.020497
Min length	9

Characters and Unicode

Total characters	890712
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	88837 ?
Unique (%)	99.9%

Sample

1st row	SEA87LA080
2nd row	LAX94LA336
3rd row	NYC07LA005
4th row	LAX96LA321
5th row	CHI79FA064

Value	Count	Frequency (%)
cen22la149	2	< 0.1%
dca23wa071	2	< 0.1%
wpr23la041	2	< 0.1%
era22la364	2	< 0.1%
cen23ma034	2	< 0.1%
dca22la135	2	< 0.1%
dca22wa204	2	< 0.1%
dca22la201	2	< 0.1%
gaa22wa241	2	< 0.1%
cen22la346	2	< 0.1%
Other values (88853)	88869	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
A	135499	15.2%
0	83449	9.4%
1	71377	8.0%
L	65252	7.3%
2	48846	5.5%
8	48646	5.5%
9	46740	5.2%
C	43991	4.9%
3	34494	3.9%
4	29450	3.3%
Other values (27)	282968	31.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	890712	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	135499	15.2%
0	83449	9.4%
1	71377	8.0%
L	65252	7.3%
2	48846	5.5%
8	48646	5.5%
9	46740	5.2%
C	43991	4.9%
3	34494	3.9%
4	29450	3.3%
Other values (27)	282968	31.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	890712	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	135499	15.2%
0	83449	9.4%
1	71377	8.0%
L	65252	7.3%
2	48846	5.5%
8	48646	5.5%
9	46740	5.2%
C	43991	4.9%
3	34494	3.9%
4	29450	3.3%
Other values (27)	282968	31.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	890712	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	135499	15.2%
0	83449	9.4%
1	71377	8.0%
L	65252	7.3%
2	48846	5.5%
8	48646	5.5%
9	46740	5.2%
C	43991	4.9%
3	34494	3.9%
4	29450	3.3%
Other values (27)	282968	31.8%

Event.Date
Date

Distinct	14782
Distinct (%)	16.6%
Missing	0
Missing (%)	0.0%
Memory size	694.6 KiB

Minimum	1948-10-24 00:00:00
Maximum	2022-12-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Location
Text

Distinct	27758
Distinct (%)	31.2%
Missing	52
Missing (%)	0.1%
Memory size	694.6 KiB

Length

Max length	63
Median length	56
Mean length	13.043743
Min length	1

Characters and Unicode

Total characters	1158767
Distinct characters	92
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16801 ?
Unique (%)	18.9%

Sample

1st row	MOOSE CREEK, ID
2nd row	BRIDGEPORT, CA
3rd row	Saltville, VA
4th row	EUREKA, CA
5th row	Canton, OH

Value	Count	Frequency (%)
ca	8859	4.4%
tx	5913	2.9%
fl	5827	2.9%
ak	5672	2.8%
az	2834	1.4%
co	2730	1.3%
wa	2615	1.3%
city	2109	1.0%
il	2061	1.0%
mi	2036	1.0%
Other values (14112)	162442	80.0%

Most occurring characters

Value	Count	Frequency (%)
	114532	9.9%
,	88855	7.7%
A	87911	7.6%
N	55643	4.8%
E	53820	4.6%
L	53670	4.6%
O	49966	4.3%
I	43133	3.7%
T	40180	3.5%
R	39988	3.5%
Other values (82)	531069	45.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1158767	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	114532	9.9%
,	88855	7.7%
A	87911	7.6%
N	55643	4.8%
E	53820	4.6%
L	53670	4.6%
O	49966	4.3%
I	43133	3.7%
T	40180	3.5%
R	39988	3.5%
Other values (82)	531069	45.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1158767	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	114532	9.9%
,	88855	7.7%
A	87911	7.6%
N	55643	4.8%
E	53820	4.6%
L	53670	4.6%
O	49966	4.3%
I	43133	3.7%
T	40180	3.5%
R	39988	3.5%
Other values (82)	531069	45.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1158767	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	114532	9.9%
,	88855	7.7%
A	87911	7.6%
N	55643	4.8%
E	53820	4.6%
L	53670	4.6%
O	49966	4.3%
I	43133	3.7%
T	40180	3.5%
R	39988	3.5%
Other values (82)	531069	45.8%

Country
Text

Distinct	219
Distinct (%)	0.2%
Missing	226
Missing (%)	0.3%
Memory size	694.6 KiB

Length

Max length	32
Median length	13
Mean length	12.649155
Min length	2

Characters and Unicode

Total characters	1121512
Distinct characters	59
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	< 0.1%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Value	Count	Frequency (%)
united	82594	47.9%
states	82251	47.7%
mexico	388	0.2%
brazil	374	0.2%
canada	359	0.2%
kingdom	344	0.2%
australia	300	0.2%
france	236	0.1%
spain	226	0.1%
bahamas	216	0.1%
Other values (241)	5033	2.9%

Most occurring characters

Value	Count	Frequency (%)
t	248529	22.2%
e	167964	15.0%
a	89874	8.0%
i	86783	7.7%
n	86419	7.7%
d	84220	7.5%
s	83718	7.5%
	83658	7.5%
S	82976	7.4%
U	82682	7.4%
Other values (49)	24689	2.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1121512	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	248529	22.2%
e	167964	15.0%
a	89874	8.0%
i	86783	7.7%
n	86419	7.7%
d	84220	7.5%
s	83718	7.5%
	83658	7.5%
S	82976	7.4%
U	82682	7.4%
Other values (49)	24689	2.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1121512	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	248529	22.2%
e	167964	15.0%
a	89874	8.0%
i	86783	7.7%
n	86419	7.7%
d	84220	7.5%
s	83718	7.5%
	83658	7.5%
S	82976	7.4%
U	82682	7.4%
Other values (49)	24689	2.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1121512	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	248529	22.2%
e	167964	15.0%
a	89874	8.0%
i	86783	7.7%
n	86419	7.7%
d	84220	7.5%
s	83718	7.5%
	83658	7.5%
S	82976	7.4%
U	82682	7.4%
Other values (49)	24689	2.2%

Latitude
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	54507
Missing (%)	61.3%
Memory size	694.6 KiB

Longitude
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	54516
Missing (%)	61.3%
Memory size	694.6 KiB

Airport.Code
Text

MISSING

Distinct	10374
Distinct (%)	20.7%
Missing	38757
Missing (%)	43.6%
Memory size	694.6 KiB

Length

Max length	8
Median length	3
Mean length	3.1662411
Min length	1

Characters and Unicode

Total characters	158730
Distinct characters	73
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4753 ?
Unique (%)	9.5%

Sample

1st row	N58
2nd row	JAX
3rd row	T72
4th row	5G6
5th row	YIP

Value	Count	Frequency (%)
none	1495	3.0%
pvt	497	1.0%
apa	160	0.3%
ord	149	0.3%
mri	137	0.3%
den	115	0.2%
osh	109	0.2%
bjc	102	0.2%
vny	100	0.2%
ffz	98	0.2%
Other values (10335)	47175	94.1%

Most occurring characters

Value	Count	Frequency (%)
N	8419	5.3%
A	7982	5.0%
S	7247	4.6%
O	6688	4.2%
L	6526	4.1%
C	6126	3.9%
E	5813	3.7%
M	5740	3.6%
T	5616	3.5%
K	5337	3.4%
Other values (63)	93236	58.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	158730	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	8419	5.3%
A	7982	5.0%
S	7247	4.6%
O	6688	4.2%
L	6526	4.1%
C	6126	3.9%
E	5813	3.7%
M	5740	3.6%
T	5616	3.5%
K	5337	3.4%
Other values (63)	93236	58.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	158730	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	8419	5.3%
A	7982	5.0%
S	7247	4.6%
O	6688	4.2%
L	6526	4.1%
C	6126	3.9%
E	5813	3.7%
M	5740	3.6%
T	5616	3.5%
K	5337	3.4%
Other values (63)	93236	58.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	158730	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	8419	5.3%
A	7982	5.0%
S	7247	4.6%
O	6688	4.2%
L	6526	4.1%
C	6126	3.9%
E	5813	3.7%
M	5740	3.6%
T	5616	3.5%
K	5337	3.4%
Other values (63)	93236	58.7%

Airport.Name
Text

MISSING

Distinct	24870
Distinct (%)	47.2%
Missing	36185
Missing (%)	40.7%
Memory size	694.6 KiB

Length

Max length	30
Median length	21
Mean length	15.687102
Min length	1

Characters and Unicode

Total characters	826773
Distinct characters	96
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16532 ?
Unique (%)	31.4%

Sample

1st row	BLACKBURN AG STRIP
2nd row	HANOVER
3rd row	JACKSONVILLE INTL
4th row	TUSKEGEE
5th row	HEARNE MUNICIPAL

Value	Count	Frequency (%)
airport	8635	7.5%
municipal	4458	3.8%
county	3873	3.3%
field	3366	2.9%
muni	2322	2.0%
regional	1822	1.6%
international	1783	1.5%
private	1202	1.0%
intl	1147	1.0%
lake	1030	0.9%
Other values (10671)	86253	74.4%

Most occurring characters

Value	Count	Frequency (%)
	63201	7.6%
A	53752	6.5%
E	39960	4.8%
I	39036	4.7%
N	39020	4.7%
R	37118	4.5%
L	35167	4.3%
r	31576	3.8%
O	31284	3.8%
i	29096	3.5%
Other values (86)	427563	51.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	826773	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	63201	7.6%
A	53752	6.5%
E	39960	4.8%
I	39036	4.7%
N	39020	4.7%
R	37118	4.5%
L	35167	4.3%
r	31576	3.8%
O	31284	3.8%
i	29096	3.5%
Other values (86)	427563	51.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	826773	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	63201	7.6%
A	53752	6.5%
E	39960	4.8%
I	39036	4.7%
N	39020	4.7%
R	37118	4.5%
L	35167	4.3%
r	31576	3.8%
O	31284	3.8%
i	29096	3.5%
Other values (86)	427563	51.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	826773	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	63201	7.6%
A	53752	6.5%
E	39960	4.8%
I	39036	4.7%
N	39020	4.7%
R	37118	4.5%
L	35167	4.3%
r	31576	3.8%
O	31284	3.8%
i	29096	3.5%
Other values (86)	427563	51.7%

Injury.Severity
Text

MISSING

Distinct	109
Distinct (%)	0.1%
Missing	1000
Missing (%)	1.1%
Memory size	694.6 KiB

Length

Max length	11
Median length	9
Mean length	8.5835201
Min length	5

Characters and Unicode

Total characters	754397
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59 ?
Unique (%)	0.1%

Sample

1st row	Fatal(2)
2nd row	Fatal(4)
3rd row	Fatal(3)
4th row	Fatal(2)
5th row	Fatal(1)

Value	Count	Frequency (%)
non-fatal	67357	76.6%
fatal(1	6167	7.0%
fatal	5262	6.0%
fatal(2	3711	4.2%
incident	2219	2.5%
fatal(3	1147	1.3%
fatal(4	812	0.9%
fatal(5	235	0.3%
minor	218	0.2%
serious	173	0.2%
Other values (99)	588	0.7%

Most occurring characters

Value	Count	Frequency (%)
a	170654	22.6%
t	87402	11.6%
l	85375	11.3%
F	85183	11.3%
n	72109	9.6%
o	67748	9.0%
N	67357	8.9%
-	67357	8.9%
(	12564	1.7%
)	12564	1.7%
Other values (23)	26084	3.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	754397	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	170654	22.6%
t	87402	11.6%
l	85375	11.3%
F	85183	11.3%
n	72109	9.6%
o	67748	9.0%
N	67357	8.9%
-	67357	8.9%
(	12564	1.7%
)	12564	1.7%
Other values (23)	26084	3.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	754397	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	170654	22.6%
t	87402	11.6%
l	85375	11.3%
F	85183	11.3%
n	72109	9.6%
o	67748	9.0%
N	67357	8.9%
-	67357	8.9%
(	12564	1.7%
)	12564	1.7%
Other values (23)	26084	3.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	754397	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	170654	22.6%
t	87402	11.6%
l	85375	11.3%
F	85183	11.3%
n	72109	9.6%
o	67748	9.0%
N	67357	8.9%
-	67357	8.9%
(	12564	1.7%
)	12564	1.7%
Other values (23)	26084	3.5%

Aircraft.damage
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	3194
Missing (%)	3.6%
Memory size	694.6 KiB

Substantial	64148
Destroyed	18623
Minor	2805
Unknown	119

Length

Max length	11
Median length	11
Mean length	10.363417
Min length	5

Characters and Unicode

Total characters	888093
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Destroyed
2nd row	Destroyed
3rd row	Destroyed
4th row	Destroyed
5th row	Destroyed

Common Values

Value	Count	Frequency (%)
Substantial	64148	72.2%
Destroyed	18623	21.0%
Minor	2805	3.2%
Unknown	119	0.1%
(Missing)	3194	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
substantial	64148	74.9%
destroyed	18623	21.7%
minor	2805	3.3%
unknown	119	0.1%

Most occurring characters

Value	Count	Frequency (%)
t	146919	16.5%
a	128296	14.4%
s	82771	9.3%
n	67310	7.6%
i	66953	7.5%
S	64148	7.2%
b	64148	7.2%
l	64148	7.2%
u	64148	7.2%
e	37246	4.2%
Other values (9)	102006	11.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	888093	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	146919	16.5%
a	128296	14.4%
s	82771	9.3%
n	67310	7.6%
i	66953	7.5%
S	64148	7.2%
b	64148	7.2%
l	64148	7.2%
u	64148	7.2%
e	37246	4.2%
Other values (9)	102006	11.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	888093	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	146919	16.5%
a	128296	14.4%
s	82771	9.3%
n	67310	7.6%
i	66953	7.5%
S	64148	7.2%
b	64148	7.2%
l	64148	7.2%
u	64148	7.2%
e	37246	4.2%
Other values (9)	102006	11.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	888093	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	146919	16.5%
a	128296	14.4%
s	82771	9.3%
n	67310	7.6%
i	66953	7.5%
S	64148	7.2%
b	64148	7.2%
l	64148	7.2%
u	64148	7.2%
e	37246	4.2%
Other values (9)	102006	11.5%

Aircraft.Category
Categorical

IMBALANCE MISSING

Distinct	15
Distinct (%)	< 0.1%
Missing	56602
Missing (%)	63.7%
Memory size	694.6 KiB

Airplane	27617
Helicopter	3440
Glider	508
Balloon	231
Gyrocraft	173
Other values (10)	318

Length

Max length	17
Median length	8
Mean length	8.225199
Min length	3

Characters and Unicode

Total characters	265567
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Airplane
2nd row	Airplane
3rd row	Airplane
4th row	Airplane
5th row	Airplane

Common Values

Value	Count	Frequency (%)
Airplane	27617	31.1%
Helicopter	3440	3.9%
Glider	508	0.6%
Balloon	231	0.3%
Gyrocraft	173	0.2%
Weight-Shift	161	0.2%
Powered Parachute	91	0.1%
Ultralight	30	< 0.1%
Unknown	14	< 0.1%
WSFT	9	< 0.1%
Other values (5)	13	< 0.1%
(Missing)	56602	63.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
airplane	27617	85.3%
helicopter	3440	10.6%
glider	508	1.6%
balloon	231	0.7%
gyrocraft	173	0.5%
weight-shift	161	0.5%
powered	91	0.3%
parachute	91	0.3%
ultralight	30	0.1%
unknown	14	< 0.1%
Other values (6)	22	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	35450	13.3%
r	32128	12.1%
l	32091	12.1%
i	31926	12.0%
p	31061	11.7%
a	28233	10.6%
n	27890	10.5%
A	27617	10.4%
o	4186	1.6%
t	4092	1.5%
Other values (25)	10893	4.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	265567	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	35450	13.3%
r	32128	12.1%
l	32091	12.1%
i	31926	12.0%
p	31061	11.7%
a	28233	10.6%
n	27890	10.5%
A	27617	10.4%
o	4186	1.6%
t	4092	1.5%
Other values (25)	10893	4.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	265567	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	35450	13.3%
r	32128	12.1%
l	32091	12.1%
i	31926	12.0%
p	31061	11.7%
a	28233	10.6%
n	27890	10.5%
A	27617	10.4%
o	4186	1.6%
t	4092	1.5%
Other values (25)	10893	4.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	265567	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	35450	13.3%
r	32128	12.1%
l	32091	12.1%
i	31926	12.0%
p	31061	11.7%
a	28233	10.6%
n	27890	10.5%
A	27617	10.4%
o	4186	1.6%
t	4092	1.5%
Other values (25)	10893	4.1%

Registration.Number
Text

MISSING

Distinct	79104
Distinct (%)	90.4%
Missing	1382
Missing (%)	1.6%
Memory size	694.6 KiB

Length

Max length	11
Median length	6
Mean length	5.8413156
Min length	2

Characters and Unicode

Total characters	511156
Distinct characters	63
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	72052 ?
Unique (%)	82.3%

Sample

1st row	NC6404
2nd row	N5069P
3rd row	N5142R
4th row	N1168J
5th row	N15NY

Value	Count	Frequency (%)
none	346	0.4%
unreg	131	0.1%
unk	14	< 0.1%
unknown	10	< 0.1%
usaf	9	< 0.1%
n20752	8	< 0.1%
n4101e	6	< 0.1%
n53893	6	< 0.1%
n8402k	6	< 0.1%
n121cc	6	< 0.1%
Other values (79101)	86987	99.4%

Most occurring characters

Value	Count	Frequency (%)
N	86835	17.0%
1	35488	6.9%
2	34100	6.7%
3	32265	6.3%
5	31999	6.3%
4	31810	6.2%
6	30787	6.0%
7	30551	6.0%
9	29561	5.8%
8	29359	5.7%
Other values (53)	138401	27.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	511156	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	86835	17.0%
1	35488	6.9%
2	34100	6.7%
3	32265	6.3%
5	31999	6.3%
4	31810	6.2%
6	30787	6.0%
7	30551	6.0%
9	29561	5.8%
8	29359	5.7%
Other values (53)	138401	27.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	511156	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	86835	17.0%
1	35488	6.9%
2	34100	6.7%
3	32265	6.3%
5	31999	6.3%
4	31810	6.2%
6	30787	6.0%
7	30551	6.0%
9	29561	5.8%
8	29359	5.7%
Other values (53)	138401	27.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	511156	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	86835	17.0%
1	35488	6.9%
2	34100	6.7%
3	32265	6.3%
5	31999	6.3%
4	31810	6.2%
6	30787	6.0%
7	30551	6.0%
9	29561	5.8%
8	29359	5.7%
Other values (53)	138401	27.1%

Make
Text

Distinct	8237
Distinct (%)	9.3%
Missing	63
Missing (%)	0.1%
Memory size	694.6 KiB

Length

Max length	30
Median length	29
Mean length	7.5983608
Min length	2

Characters and Unicode

Total characters	674932
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6625 ?
Unique (%)	7.5%

Sample

1st row	Stinson
2nd row	Piper
3rd row	Cessna
4th row	Rockwell
5th row	Cessna

Value	Count	Frequency (%)
cessna	27210	25.2%
piper	14935	13.8%
beech	5384	5.0%
boeing	2830	2.6%
bell	2792	2.6%
robinson	1688	1.6%
grumman	1520	1.4%
mooney	1385	1.3%
aircraft	1208	1.1%
american	1063	1.0%
Other values (6488)	47868	44.4%

Most occurring characters

Value	Count	Frequency (%)
e	69239	10.3%
s	55264	8.2%
a	42583	6.3%
n	41651	6.2%
C	39022	5.8%
r	32996	4.9%
i	27823	4.1%
E	23396	3.5%
A	21608	3.2%
P	21403	3.2%
Other values (66)	299947	44.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	674932	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	69239	10.3%
s	55264	8.2%
a	42583	6.3%
n	41651	6.2%
C	39022	5.8%
r	32996	4.9%
i	27823	4.1%
E	23396	3.5%
A	21608	3.2%
P	21403	3.2%
Other values (66)	299947	44.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	674932	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	69239	10.3%
s	55264	8.2%
a	42583	6.3%
n	41651	6.2%
C	39022	5.8%
r	32996	4.9%
i	27823	4.1%
E	23396	3.5%
A	21608	3.2%
P	21403	3.2%
Other values (66)	299947	44.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	674932	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	69239	10.3%
s	55264	8.2%
a	42583	6.3%
n	41651	6.2%
C	39022	5.8%
r	32996	4.9%
i	27823	4.1%
E	23396	3.5%
A	21608	3.2%
P	21403	3.2%
Other values (66)	299947	44.4%

Model
Text

Distinct	12318
Distinct (%)	13.9%
Missing	92
Missing (%)	0.1%
Memory size	694.6 KiB

Length

Max length	20
Median length	18
Mean length	5.75578
Min length	1

Characters and Unicode

Total characters	511096
Distinct characters	84
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7615 ?
Unique (%)	8.6%

Sample

1st row	108-3
2nd row	PA24-180
3rd row	172M
4th row	112
5th row	501

Value	Count	Frequency (%)
152	2393	2.3%
172	1821	1.8%
172n	1166	1.1%
ii	1077	1.0%
pa-28-140	933	0.9%
150	865	0.8%
172m	798	0.8%
pa	696	0.7%
172p	692	0.7%
182	673	0.7%
Other values (9367)	91473	89.2%

Most occurring characters

Value	Count	Frequency (%)
2	50120	9.8%
1	49809	9.7%
-	45177	8.8%
0	37339	7.3%
A	35320	6.9%
5	21225	4.2%
8	20368	4.0%
3	20146	3.9%
7	19919	3.9%
P	19025	3.7%
Other values (74)	192648	37.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	511096	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	50120	9.8%
1	49809	9.7%
-	45177	8.8%
0	37339	7.3%
A	35320	6.9%
5	21225	4.2%
8	20368	4.0%
3	20146	3.9%
7	19919	3.9%
P	19025	3.7%
Other values (74)	192648	37.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	511096	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	50120	9.8%
1	49809	9.7%
-	45177	8.8%
0	37339	7.3%
A	35320	6.9%
5	21225	4.2%
8	20368	4.0%
3	20146	3.9%
7	19919	3.9%
P	19025	3.7%
Other values (74)	192648	37.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	511096	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	50120	9.8%
1	49809	9.7%
-	45177	8.8%
0	37339	7.3%
A	35320	6.9%
5	21225	4.2%
8	20368	4.0%
3	20146	3.9%
7	19919	3.9%
P	19025	3.7%
Other values (74)	192648	37.7%

Amateur.Built
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	102
Missing (%)	0.1%
Memory size	173.7 KiB

False	80312
True	8475
(Missing)	102

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	80312	90.4%
True	8475	9.5%
(Missing)	102	0.1%

Number.of.Engines
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	6084
Missing (%)	6.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.1465854

Minimum	0
Maximum	8
Zeros	1226
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	694.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.44651021
Coefficient of variation (CV)	0.38942606
Kurtosis	12.031895
Mean	1.1465854
Median Absolute Deviation (MAD)	0
Skewness	2.5759042
Sum	94943
Variance	0.19937137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	69582	78.3%
2	11079	12.5%
0	1226	1.4%
3	483	0.5%
4	431	0.5%
8	3	< 0.1%
6	1	< 0.1%
(Missing)	6084	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1226	1.4%
1	69582	78.3%
2	11079	12.5%
3	483	0.5%
4	431	0.5%
6	1	< 0.1%
8	3	< 0.1%

Value	Count	Frequency (%)
8	3	< 0.1%
6	1	< 0.1%
4	431	0.5%
3	483	0.5%
2	11079	12.5%
1	69582	78.3%
0	1226	1.4%

Engine.Type
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	7096
Missing (%)	8.0%
Memory size	694.6 KiB

Reciprocating	69530
Turbo Shaft	3609
Turbo Prop	3391
Turbo Fan	2481
Unknown	2051
Other values (7)	731

Length

Max length	15
Median length	13
Mean length	12.480286
Min length	2

Characters and Unicode

Total characters	1020800
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Reciprocating
2nd row	Reciprocating
3rd row	Reciprocating
4th row	Reciprocating
5th row	Turbo Fan

Common Values

Value	Count	Frequency (%)
Reciprocating	69530	78.2%
Turbo Shaft	3609	4.1%
Turbo Prop	3391	3.8%
Turbo Fan	2481	2.8%
Unknown	2051	2.3%
Turbo Jet	703	0.8%
Geared Turbofan	12	< 0.1%
Electric	10	< 0.1%
LR	2	< 0.1%
NONE	2	< 0.1%
Other values (2)	2	< 0.1%
(Missing)	7096	8.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
reciprocating	69530	75.6%
turbo	10184	11.1%
shaft	3609	3.9%
prop	3391	3.7%
fan	2481	2.7%
unknown	2051	2.2%
jet	703	0.8%
geared	12	< 0.1%
turbofan	12	< 0.1%
electric	10	< 0.1%
Other values (5)	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
c	139081	13.6%
i	139071	13.6%
o	85169	8.3%
r	83140	8.1%
n	78176	7.7%
a	75644	7.4%
t	73853	7.2%
p	72921	7.1%
e	70268	6.9%
R	69533	6.8%
Other values (24)	133944	13.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1020800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
c	139081	13.6%
i	139071	13.6%
o	85169	8.3%
r	83140	8.1%
n	78176	7.7%
a	75644	7.4%
t	73853	7.2%
p	72921	7.1%
e	70268	6.9%
R	69533	6.8%
Other values (24)	133944	13.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1020800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
c	139081	13.6%
i	139071	13.6%
o	85169	8.3%
r	83140	8.1%
n	78176	7.7%
a	75644	7.4%
t	73853	7.2%
p	72921	7.1%
e	70268	6.9%
R	69533	6.8%
Other values (24)	133944	13.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1020800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
c	139081	13.6%
i	139071	13.6%
o	85169	8.3%
r	83140	8.1%
n	78176	7.7%
a	75644	7.4%
t	73853	7.2%
p	72921	7.1%
e	70268	6.9%
R	69533	6.8%
Other values (24)	133944	13.1%

FAR.Description
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	31
Distinct (%)	0.1%
Missing	56866
Missing (%)	64.0%
Memory size	694.6 KiB

091	18221
Part 91: General Aviation	6486
NUSN	1584
NUSC	1013
137	1010
Other values (26)	3709

Length

Max length	30
Median length	3
Mean length	8.3364769
Min length	3

Characters and Unicode

Total characters	266959
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Part 129: Foreign
2nd row	Part 91: General Aviation
3rd row	Part 91: General Aviation
4th row	Part 91: General Aviation
5th row	Part 91: General Aviation

Common Values

Value	Count	Frequency (%)
091	18221	20.5%
Part 91: General Aviation	6486	7.3%
NUSN	1584	1.8%
NUSC	1013	1.1%
137	1010	1.1%
135	746	0.8%
121	679	0.8%
Part 137: Agricultural	437	0.5%
UNK	371	0.4%
Part 135: Air Taxi & Commuter	298	0.3%
Other values (21)	1178	1.3%
(Missing)	56866	64.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
091	18221	33.2%
part	7525	13.7%
91	6487	11.8%
general	6486	11.8%
aviation	6486	11.8%
nusn	1584	2.9%
137	1447	2.6%
135	1044	1.9%
nusc	1013	1.8%
121	844	1.5%
Other values (39)	3771	6.9%

Most occurring characters

Value	Count	Frequency (%)
1	29403	11.0%
9	25069	9.4%
	22885	8.6%
a	21662	8.1%
0	18261	6.8%
r	16503	6.2%
t	14847	5.6%
i	14650	5.5%
e	13747	5.1%
n	13426	5.0%
Other values (43)	76506	28.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	266959	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	29403	11.0%
9	25069	9.4%
	22885	8.6%
a	21662	8.1%
0	18261	6.8%
r	16503	6.2%
t	14847	5.6%
i	14650	5.5%
e	13747	5.1%
n	13426	5.0%
Other values (43)	76506	28.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	266959	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	29403	11.0%
9	25069	9.4%
	22885	8.6%
a	21662	8.1%
0	18261	6.8%
r	16503	6.2%
t	14847	5.6%
i	14650	5.5%
e	13747	5.1%
n	13426	5.0%
Other values (43)	76506	28.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	266959	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	29403	11.0%
9	25069	9.4%
	22885	8.6%
a	21662	8.1%
0	18261	6.8%
r	16503	6.2%
t	14847	5.6%
i	14650	5.5%
e	13747	5.1%
n	13426	5.0%
Other values (43)	76506	28.7%

Schedule
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	76307
Missing (%)	85.8%
Memory size	694.6 KiB

NSCH	4474
UNK	4099
SCHD	4009

Length

Max length	4
Median length	4
Mean length	3.6742171
Min length	3

Characters and Unicode

Total characters	46229
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SCHD
2nd row	NSCH
3rd row	NSCH
4th row	SCHD
5th row	NSCH

Common Values

Value	Count	Frequency (%)
NSCH	4474	5.0%
UNK	4099	4.6%
SCHD	4009	4.5%
(Missing)	76307	85.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
nsch	4474	35.6%
unk	4099	32.6%
schd	4009	31.9%

Most occurring characters

Value	Count	Frequency (%)
N	8573	18.5%
S	8483	18.3%
C	8483	18.3%
H	8483	18.3%
U	4099	8.9%
K	4099	8.9%
D	4009	8.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	46229	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	8573	18.5%
S	8483	18.3%
C	8483	18.3%
H	8483	18.3%
U	4099	8.9%
K	4099	8.9%
D	4009	8.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	46229	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	8573	18.5%
S	8483	18.3%
C	8483	18.3%
H	8483	18.3%
U	4099	8.9%
K	4099	8.9%
D	4009	8.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	46229	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	8573	18.5%
S	8483	18.3%
C	8483	18.3%
H	8483	18.3%
U	4099	8.9%
K	4099	8.9%
D	4009	8.7%

Purpose.of.flight
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	26
Distinct (%)	< 0.1%
Missing	6192
Missing (%)	7.0%
Memory size	694.6 KiB

Personal	49448
Instructional	10601
Unknown	6802
Aerial Application	4712
Business	4018
Other values (21)	7116

Length

Max length	25
Median length	8
Mean length	9.5665985
Min length	4

Characters and Unicode

Total characters	791129
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Personal
2nd row	Personal
3rd row	Personal
4th row	Personal
5th row	Personal

Common Values

Value	Count	Frequency (%)
Personal	49448	55.6%
Instructional	10601	11.9%
Unknown	6802	7.7%
Aerial Application	4712	5.3%
Business	4018	4.5%
Positioning	1646	1.9%
Other Work Use	1264	1.4%
Ferry	812	0.9%
Aerial Observation	794	0.9%
Public Aircraft	720	0.8%
Other values (16)	1880	2.1%
(Missing)	6192	7.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
personal	49448	53.1%
instructional	10601	11.4%
unknown	6802	7.3%
aerial	5506	5.9%
application	4712	5.1%
business	4018	4.3%
positioning	1646	1.8%
other	1264	1.4%
work	1264	1.4%
use	1264	1.4%
Other values (26)	6605	7.1%

Most occurring characters

Value	Count	Frequency (%)
n	104419	13.2%
o	78539	9.9%
s	76370	9.7%
r	74135	9.4%
a	73325	9.3%
l	71990	9.1%
e	65919	8.3%
P	52062	6.6%
i	38871	4.9%
t	32788	4.1%
Other values (31)	122711	15.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	791129	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	104419	13.2%
o	78539	9.9%
s	76370	9.7%
r	74135	9.4%
a	73325	9.3%
l	71990	9.1%
e	65919	8.3%
P	52062	6.6%
i	38871	4.9%
t	32788	4.1%
Other values (31)	122711	15.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	791129	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	104419	13.2%
o	78539	9.9%
s	76370	9.7%
r	74135	9.4%
a	73325	9.3%
l	71990	9.1%
e	65919	8.3%
P	52062	6.6%
i	38871	4.9%
t	32788	4.1%
Other values (31)	122711	15.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	791129	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	104419	13.2%
o	78539	9.9%
s	76370	9.7%
r	74135	9.4%
a	73325	9.3%
l	71990	9.1%
e	65919	8.3%
P	52062	6.6%
i	38871	4.9%
t	32788	4.1%
Other values (31)	122711	15.5%

Air.carrier
Text

MISSING

Distinct	13590
Distinct (%)	81.6%
Missing	72241
Missing (%)	81.3%
Memory size	694.6 KiB

Length

Max length	90
Median length	65
Mean length	20.324003
Min length	3

Characters and Unicode

Total characters	338354
Distinct characters	95
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12395 ?
Unique (%)	74.5%

Sample

1st row	Air Canada
2nd row	Rocky Mountain Helicopters, In
3rd row	Lang Air Service
4th row	Empire Airlines
5th row	Joel Frederick's Monarch Air

Value	Count	Frequency (%)
inc	4073	7.6%
air	2324	4.3%
llc	2110	3.9%
aviation	1887	3.5%
airlines	1532	2.9%
dba	1178	2.2%
service	745	1.4%
flying	519	1.0%
helicopters	484	0.9%
flight	480	0.9%
Other values (9712)	38157	71.3%

Most occurring characters

Value	Count	Frequency (%)
	36865	10.9%
i	19440	5.7%
e	17336	5.1%
A	17267	5.1%
r	15433	4.6%
n	15121	4.5%
a	14874	4.4%
I	12944	3.8%
t	10384	3.1%
L	10371	3.1%
Other values (85)	168319	49.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	338354	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	36865	10.9%
i	19440	5.7%
e	17336	5.1%
A	17267	5.1%
r	15433	4.6%
n	15121	4.5%
a	14874	4.4%
I	12944	3.8%
t	10384	3.1%
L	10371	3.1%
Other values (85)	168319	49.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	338354	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	36865	10.9%
i	19440	5.7%
e	17336	5.1%
A	17267	5.1%
r	15433	4.6%
n	15121	4.5%
a	14874	4.4%
I	12944	3.8%
t	10384	3.1%
L	10371	3.1%
Other values (85)	168319	49.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	338354	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	36865	10.9%
i	19440	5.7%
e	17336	5.1%
A	17267	5.1%
r	15433	4.6%
n	15121	4.5%
a	14874	4.4%
I	12944	3.8%
t	10384	3.1%
L	10371	3.1%
Other values (85)	168319	49.7%

Total.Fatal.Injuries
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	125
Distinct (%)	0.2%
Missing	11401
Missing (%)	12.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.64785515

Minimum	0
Maximum	349
Zeros	59675
Zeros (%)	67.1%
Negative	0
Negative (%)	0.0%
Memory size	694.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	349
Range	349
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.4859601
Coefficient of variation (CV)	8.4678807
Kurtosis	1355.6006
Mean	0.64785515
Median Absolute Deviation (MAD)	0
Skewness	33.018675
Sum	50201
Variance	30.095758
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	59675	67.1%
1	8883	10.0%
2	5173	5.8%
3	1589	1.8%
4	1103	1.2%
5	346	0.4%
6	216	0.2%
7	101	0.1%
8	70	0.1%
10	45	0.1%
Other values (115)	287	0.3%
(Missing)	11401	12.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	59675	67.1%
1	8883	10.0%
2	5173	5.8%
3	1589	1.8%
4	1103	1.2%
5	346	0.4%
6	216	0.2%
7	101	0.1%
8	70	0.1%
9	42	< 0.1%

Value	Count	Frequency (%)
349	2	< 0.1%
295	1	< 0.1%
270	1	< 0.1%
265	1	< 0.1%
256	1	< 0.1%
239	1	< 0.1%
230	1	< 0.1%
229	1	< 0.1%
228	2	< 0.1%
224	1	< 0.1%

Total.Serious.Injuries
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	50
Distinct (%)	0.1%
Missing	12510
Missing (%)	14.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.2798806

Minimum	0
Maximum	161
Zeros	63289
Zeros (%)	71.2%
Negative	0
Negative (%)	0.0%
Memory size	694.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	161
Range	161
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.5440836
Coefficient of variation (CV)	5.5169371
Kurtosis	3737.3087
Mean	0.2798806
Median Absolute Deviation (MAD)	0
Skewness	49.400025
Sum	21377
Variance	2.3841943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	63289	71.2%
1	9125	10.3%
2	2815	3.2%
3	629	0.7%
4	258	0.3%
5	78	0.1%
6	41	< 0.1%
7	27	< 0.1%
9	16	< 0.1%
8	13	< 0.1%
Other values (40)	88	0.1%
(Missing)	12510	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	63289	71.2%
1	9125	10.3%
2	2815	3.2%
3	629	0.7%
4	258	0.3%
5	78	0.1%
6	41	< 0.1%
7	27	< 0.1%
8	13	< 0.1%
9	16	< 0.1%

Value	Count	Frequency (%)
161	1	< 0.1%
137	1	< 0.1%
125	1	< 0.1%
106	1	< 0.1%
88	1	< 0.1%
81	1	< 0.1%
67	1	< 0.1%
63	1	< 0.1%
60	1	< 0.1%
59	2	< 0.1%

Total.Minor.Injuries
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	57
Distinct (%)	0.1%
Missing	11933
Missing (%)	13.4%
Infinite	0
Infinite (%)	0.0%
Mean	0.35706118

Minimum	0
Maximum	380
Zeros	61454
Zeros (%)	69.1%
Negative	0
Negative (%)	0.0%
Memory size	694.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	380
Range	380
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.2356253
Coefficient of variation (CV)	6.2611828
Kurtosis	12365.048
Mean	0.35706118
Median Absolute Deviation (MAD)	0
Skewness	87.269476
Sum	27478
Variance	4.9980206
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	61454	69.1%
1	10320	11.6%
2	3576	4.0%
3	784	0.9%
4	372	0.4%
5	129	0.1%
6	67	0.1%
7	59	0.1%
9	22	< 0.1%
8	20	< 0.1%
Other values (47)	153	0.2%
(Missing)	11933	13.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	61454	69.1%
1	10320	11.6%
2	3576	4.0%
3	784	0.9%
4	372	0.4%
5	129	0.1%
6	67	0.1%
7	59	0.1%
8	20	< 0.1%
9	22	< 0.1%

Value	Count	Frequency (%)
380	1	< 0.1%
200	1	< 0.1%
171	1	< 0.1%
125	1	< 0.1%
96	1	< 0.1%
84	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
65	1	< 0.1%

Total.Uninjured
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	379
Distinct (%)	0.5%
Missing	5912
Missing (%)	6.7%
Infinite	0
Infinite (%)	0.0%
Mean	5.3254396

Minimum	0
Maximum	699
Zeros	29879
Zeros (%)	33.6%
Negative	0
Negative (%)	0.0%
Memory size	694.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	699
Range	699
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	27.913634
Coefficient of variation (CV)	5.2415644
Kurtosis	104.61249
Mean	5.3254396
Median Absolute Deviation (MAD)	1
Skewness	9.0861041
Sum	441889
Variance	779.17099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	29879	33.6%
1	25101	28.2%
2	15988	18.0%
3	4313	4.9%
4	2662	3.0%
5	887	1.0%
6	500	0.6%
7	281	0.3%
8	163	0.2%
9	128	0.1%
Other values (369)	3075	3.5%
(Missing)	5912	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29879	33.6%
1	25101	28.2%
2	15988	18.0%
3	4313	4.9%
4	2662	3.0%
5	887	1.0%
6	500	0.6%
7	281	0.3%
8	163	0.2%
9	128	0.1%

Value	Count	Frequency (%)
699	2	< 0.1%
588	2	< 0.1%
576	1	< 0.1%
573	2	< 0.1%
558	1	< 0.1%
528	2	< 0.1%
521	1	< 0.1%
507	1	< 0.1%
501	2	< 0.1%
495	2	< 0.1%

Weather.Condition
Categorical

IMBALANCE MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	4492
Missing (%)	5.1%
Memory size	694.6 KiB

VMC	77303
IMC	5976
UNK	856
Unk	262

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	253191
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UNK
2nd row	UNK
3rd row	IMC
4th row	IMC
5th row	VMC

Common Values

Value	Count	Frequency (%)
VMC	77303	87.0%
IMC	5976	6.7%
UNK	856	1.0%
Unk	262	0.3%
(Missing)	4492	5.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
vmc	77303	91.6%
imc	5976	7.1%
unk	1118	1.3%

Most occurring characters

Value	Count	Frequency (%)
M	83279	32.9%
C	83279	32.9%
V	77303	30.5%
I	5976	2.4%
U	1118	0.4%
N	856	0.3%
K	856	0.3%
n	262	0.1%
k	262	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	253191	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	83279	32.9%
C	83279	32.9%
V	77303	30.5%
I	5976	2.4%
U	1118	0.4%
N	856	0.3%
K	856	0.3%
n	262	0.1%
k	262	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	253191	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	83279	32.9%
C	83279	32.9%
V	77303	30.5%
I	5976	2.4%
U	1118	0.4%
N	856	0.3%
K	856	0.3%
n	262	0.1%
k	262	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	253191	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	83279	32.9%
C	83279	32.9%
V	77303	30.5%
I	5976	2.4%
U	1118	0.4%
N	856	0.3%
K	856	0.3%
n	262	0.1%
k	262	0.1%

Broad.phase.of.flight
Categorical

MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	27165
Missing (%)	30.6%
Memory size	694.6 KiB

Landing	15428
Takeoff	12493
Cruise	10269
Maneuvering	8144
Approach	6546
Other values (7)	8844

Length

Max length	11
Median length	9
Mean length	7.3616746
Min length	4

Characters and Unicode

Total characters	454392
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cruise
2nd row	Unknown
3rd row	Cruise
4th row	Cruise
5th row	Approach

Common Values

Value	Count	Frequency (%)
Landing	15428	17.4%
Takeoff	12493	14.1%
Cruise	10269	11.6%
Maneuvering	8144	9.2%
Approach	6546	7.4%
Climb	2034	2.3%
Taxi	1958	2.2%
Descent	1887	2.1%
Go-around	1353	1.5%
Standing	945	1.1%
Other values (2)	667	0.8%
(Missing)	27165	30.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
landing	15428	25.0%
takeoff	12493	20.2%
cruise	10269	16.6%
maneuvering	8144	13.2%
approach	6546	10.6%
climb	2034	3.3%
taxi	1958	3.2%
descent	1887	3.1%
go-around	1353	2.2%
standing	945	1.5%
Other values (2)	667	1.1%

Most occurring characters

Value	Count	Frequency (%)
n	53918	11.9%
a	46867	10.3%
e	42943	9.5%
i	38778	8.5%
r	26431	5.8%
f	24986	5.5%
g	24517	5.4%
o	22293	4.9%
u	19766	4.3%
d	17726	3.9%
Other values (23)	136167	30.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	454392	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	53918	11.9%
a	46867	10.3%
e	42943	9.5%
i	38778	8.5%
r	26431	5.8%
f	24986	5.5%
g	24517	5.4%
o	22293	4.9%
u	19766	4.3%
d	17726	3.9%
Other values (23)	136167	30.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	454392	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	53918	11.9%
a	46867	10.3%
e	42943	9.5%
i	38778	8.5%
r	26431	5.8%
f	24986	5.5%
g	24517	5.4%
o	22293	4.9%
u	19766	4.3%
d	17726	3.9%
Other values (23)	136167	30.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	454392	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	53918	11.9%
a	46867	10.3%
e	42943	9.5%
i	38778	8.5%
r	26431	5.8%
f	24986	5.5%
g	24517	5.4%
o	22293	4.9%
u	19766	4.3%
d	17726	3.9%
Other values (23)	136167	30.0%

Report.Status
Text

MISSING

Distinct	17074
Distinct (%)	20.7%
Missing	6384
Missing (%)	7.2%
Memory size	694.6 KiB

Length

Max length	1271
Median length	14
Mean length	46.162839
Min length	1

Characters and Unicode

Total characters	3808665
Distinct characters	97
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16566 ?
Unique (%)	20.1%

Sample

1st row	Probable Cause
2nd row	Probable Cause
3rd row	Probable Cause
4th row	Probable Cause
5th row	Probable Cause

Value	Count	Frequency (%)
cause	61819	10.7%
probable	61780	10.7%
the	46805	8.1%
to	21533	3.7%
of	17093	3.0%
a	16001	2.8%
in	12516	2.2%
and	11138	1.9%
failure	10012	1.7%
pilot's	9427	1.6%
Other values (7515)	307858	53.4%

Most occurring characters

Value	Count	Frequency (%)
	496638	13.0%
e	387731	10.2%
a	317126	8.3%
o	246796	6.5%
i	226677	6.0%
t	225545	5.9%
r	218937	5.7%
n	214769	5.6%
l	197086	5.2%
s	173379	4.6%
Other values (87)	1103981	29.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3808665	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	496638	13.0%
e	387731	10.2%
a	317126	8.3%
o	246796	6.5%
i	226677	6.0%
t	225545	5.9%
r	218937	5.7%
n	214769	5.6%
l	197086	5.2%
s	173379	4.6%
Other values (87)	1103981	29.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3808665	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	496638	13.0%
e	387731	10.2%
a	317126	8.3%
o	246796	6.5%
i	226677	6.0%
t	225545	5.9%
r	218937	5.7%
n	214769	5.6%
l	197086	5.2%
s	173379	4.6%
Other values (87)	1103981	29.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3808665	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	496638	13.0%
e	387731	10.2%
a	317126	8.3%
o	246796	6.5%
i	226677	6.0%
t	225545	5.9%
r	218937	5.7%
n	214769	5.6%
l	197086	5.2%
s	173379	4.6%
Other values (87)	1103981	29.0%

Publication.Date
Date

MISSING

Distinct	2924
Distinct (%)	3.9%
Missing	13771
Missing (%)	15.5%
Memory size	694.6 KiB

Minimum	1980-04-16 00:00:00
Maximum	2022-12-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Auto

Heatmap
Table

	Aircraft.Category	Aircraft.damage	Amateur.Built	Broad.phase.of.flight	Engine.Type	FAR.Description	Investigation.Type	Number.of.Engines	Purpose.of.flight	Schedule	Total.Fatal.Injuries	Total.Minor.Injuries	Total.Serious.Injuries	Total.Uninjured	Weather.Condition
Aircraft.Category	1.000	0.102	0.186	0.095	0.397	0.281	0.064	0.371	0.129	0.238	0.000	0.000	0.000	0.008	0.023
Aircraft.damage	0.102	1.000	0.054	0.269	0.225	0.292	0.841	0.206	0.158	0.361	0.039	0.023	0.012	0.199	0.158
Amateur.Built	0.186	0.054	1.000	0.095	0.112	0.181	0.062	0.129	0.219	0.122	0.005	0.008	0.000	0.044	0.073
Broad.phase.of.flight	0.095	0.269	0.095	1.000	0.108	0.133	0.120	0.096	0.129	0.460	0.004	0.000	0.000	0.054	0.184
Engine.Type	0.397	0.225	0.112	0.108	1.000	0.457	0.466	0.634	0.212	0.533	0.043	0.031	0.030	0.217	0.129
FAR.Description	0.281	0.292	0.181	0.133	0.457	1.000	0.556	0.276	0.336	0.839	0.106	0.211	0.067	0.236	0.363
Investigation.Type	0.064	0.841	0.062	0.120	0.466	0.556	1.000	0.404	0.321	0.524	0.000	0.015	0.006	0.351	0.075
Number.of.Engines	0.371	0.206	0.129	0.096	0.634	0.276	0.404	1.000	0.203	0.518	0.062	-0.024	-0.024	0.192	0.107
Purpose.of.flight	0.129	0.158	0.219	0.129	0.212	0.336	0.321	0.203	1.000	0.627	0.024	0.005	0.004	0.112	0.126
Schedule	0.238	0.361	0.122	0.460	0.533	0.839	0.524	0.518	0.627	1.000	0.090	0.028	0.058	0.403	0.183
Total.Fatal.Injuries	0.000	0.039	0.005	0.004	0.043	0.106	0.000	0.062	0.024	0.090	1.000	-0.119	-0.041	-0.502	0.042
Total.Minor.Injuries	0.000	0.023	0.008	0.000	0.031	0.211	0.015	-0.024	0.005	0.028	-0.119	1.000	0.099	-0.263	0.023
Total.Serious.Injuries	0.000	0.012	0.000	0.000	0.030	0.067	0.006	-0.024	0.004	0.058	-0.041	0.099	1.000	-0.280	0.024
Total.Uninjured	0.008	0.199	0.044	0.054	0.217	0.236	0.351	0.192	0.112	0.403	-0.502	-0.263	-0.280	1.000	0.052
Weather.Condition	0.023	0.158	0.073	0.184	0.129	0.363	0.075	0.107	0.126	0.183	0.042	0.023	0.024	0.052	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Event.Id	Investigation.Type	Accident.Number	Event.Date	Location	Country	Latitude	Longitude	Airport.Code	Airport.Name	Injury.Severity	Aircraft.damage	Aircraft.Category	Registration.Number	Make	Model	Amateur.Built	Number.of.Engines	Engine.Type	FAR.Description	Schedule	Purpose.of.flight	Air.carrier	Total.Fatal.Injuries	Total.Serious.Injuries	Total.Minor.Injuries	Total.Uninjured	Weather.Condition	Broad.phase.of.flight	Report.Status	Publication.Date
0	20001218X45444	Accident	SEA87LA080	1948-10-24	MOOSE CREEK, ID	United States	NaN	NaN	NaN	NaN	Fatal(2)	Destroyed	NaN	NC6404	Stinson	108-3	No	1.0	Reciprocating	NaN	NaN	Personal	NaN	2.0	0.0	0.0	0.0	UNK	Cruise	Probable Cause	NaN
1	20001218X45447	Accident	LAX94LA336	1962-07-19	BRIDGEPORT, CA	United States	NaN	NaN	NaN	NaN	Fatal(4)	Destroyed	NaN	N5069P	Piper	PA24-180	No	1.0	Reciprocating	NaN	NaN	Personal	NaN	4.0	0.0	0.0	0.0	UNK	Unknown	Probable Cause	19-09-1996
2	20061025X01555	Accident	NYC07LA005	1974-08-30	Saltville, VA	United States	36.922223	-81.878056	NaN	NaN	Fatal(3)	Destroyed	NaN	N5142R	Cessna	172M	No	1.0	Reciprocating	NaN	NaN	Personal	NaN	3.0	NaN	NaN	NaN	IMC	Cruise	Probable Cause	26-02-2007
3	20001218X45448	Accident	LAX96LA321	1977-06-19	EUREKA, CA	United States	NaN	NaN	NaN	NaN	Fatal(2)	Destroyed	NaN	N1168J	Rockwell	112	No	1.0	Reciprocating	NaN	NaN	Personal	NaN	2.0	0.0	0.0	0.0	IMC	Cruise	Probable Cause	12-09-2000
4	20041105X01764	Accident	CHI79FA064	1979-08-02	Canton, OH	United States	NaN	NaN	NaN	NaN	Fatal(1)	Destroyed	NaN	N15NY	Cessna	501	No	NaN	NaN	NaN	NaN	Personal	NaN	1.0	2.0	NaN	0.0	VMC	Approach	Probable Cause	16-04-1980
5	20170710X52551	Accident	NYC79AA106	1979-09-17	BOSTON, MA	United States	42.445277	-70.758333	NaN	NaN	Non-Fatal	Substantial	Airplane	CF-TLU	Mcdonnell Douglas	DC9	No	2.0	Turbo Fan	Part 129: Foreign	SCHD	NaN	Air Canada	NaN	NaN	1.0	44.0	VMC	Climb	Probable Cause	19-09-2017
6	20001218X45446	Accident	CHI81LA106	1981-08-01	COTTON, MN	United States	NaN	NaN	NaN	NaN	Fatal(4)	Destroyed	NaN	N4988E	Cessna	180	No	1.0	Reciprocating	NaN	NaN	Personal	NaN	4.0	0.0	0.0	0.0	IMC	Unknown	Probable Cause	06-11-2001
7	20020909X01562	Accident	SEA82DA022	1982-01-01	PULLMAN, WA	United States	NaN	NaN	NaN	BLACKBURN AG STRIP	Non-Fatal	Substantial	Airplane	N2482N	Cessna	140	No	1.0	Reciprocating	Part 91: General Aviation	NaN	Personal	NaN	0.0	0.0	0.0	2.0	VMC	Takeoff	Probable Cause	01-01-1982
8	20020909X01561	Accident	NYC82DA015	1982-01-01	EAST HANOVER, NJ	United States	NaN	NaN	N58	HANOVER	Non-Fatal	Substantial	Airplane	N7967Q	Cessna	401B	No	2.0	Reciprocating	Part 91: General Aviation	NaN	Business	NaN	0.0	0.0	0.0	2.0	IMC	Landing	Probable Cause	01-01-1982
9	20020909X01560	Accident	MIA82DA029	1982-01-01	JACKSONVILLE, FL	United States	NaN	NaN	JAX	JACKSONVILLE INTL	Non-Fatal	Substantial	NaN	N3906K	North American	NAVION L-17B	No	1.0	Reciprocating	NaN	NaN	Personal	NaN	0.0	0.0	3.0	0.0	IMC	Cruise	Probable Cause	01-01-1982

	Event.Id	Investigation.Type	Accident.Number	Event.Date	Location	Country	Latitude	Longitude	Airport.Code	Airport.Name	Injury.Severity	Aircraft.damage	Aircraft.Category	Registration.Number	Make	Model	Amateur.Built	Number.of.Engines	Engine.Type	FAR.Description	Schedule	Purpose.of.flight	Air.carrier	Total.Fatal.Injuries	Total.Serious.Injuries	Total.Uninjured	Weather.Condition	Broad.phase.of.flight	Report.Status	Publication.Date
88879	20221219106472	Accident	DCA23LA096	2022-12-18	Kahului, HI	United States	NaN	NaN	NaN	NaN	NaN	NaN	NaN	N393HA	AIRBUS	A330-243	No	NaN	NaN	121	SCHD	NaN	HAWAIIAN AIRLINES INC	0.0	0.0	0.0	NaN	NaN	NaN	NaN
88880	20221219106477	Accident	WPR23LA071	2022-12-18	San Manual, AZ	United States	NaN	NaN	NaN	NaN	Non-Fatal	NaN	NaN	N4144P	PIPER	PA28	No	NaN	NaN	091	NaN	Personal	Chandler Air Service	0.0	0.0	3.0	NaN	NaN	NaN	20-12-2022
88881	20221221106483	Accident	CEN23LA067	2022-12-21	Auburn Hills, MI	United States	NaN	NaN	NaN	NaN	Minor	NaN	NaN	N8786U	CESSNA	172F	No	NaN	NaN	091	NSCH	Personal	Pilot	0.0	1.0	0.0	NaN	NaN	NaN	22-12-2022
88882	20221222106486	Accident	CEN23LA068	2022-12-21	Reserve, LA	United States	NaN	NaN	NaN	NaN	Minor	NaN	NaN	N321GD	GRUMMAN AMERICAN AVN. CORP.	AA-5B	No	NaN	NaN	091	NaN	Instructional	NaN	0.0	1.0	1.0	NaN	NaN	NaN	27-12-2022
88883	20221228106502	Accident	GAA23WA046	2022-12-22	Brasnorte,	Brazil	NaN	NaN	NaN	NaN	Fatal	NaN	NaN	PP-IRC	AIR TRACTOR	AT502	No	NaN	NaN	NaN	NaN	NaN	NaN	1.0	0.0	0.0	NaN	NaN	NaN	28-12-2022
88884	20221227106491	Accident	ERA23LA093	2022-12-26	Annapolis, MD	United States	NaN	NaN	NaN	NaN	Minor	NaN	NaN	N1867H	PIPER	PA-28-151	No	NaN	NaN	091	NaN	Personal	NaN	0.0	1.0	0.0	NaN	NaN	NaN	29-12-2022
88885	20221227106494	Accident	ERA23LA095	2022-12-26	Hampton, NH	United States	NaN	NaN	NaN	NaN	NaN	NaN	NaN	N2895Z	BELLANCA	7ECA	No	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN
88886	20221227106497	Accident	WPR23LA075	2022-12-26	Payson, AZ	United States	341525N	1112021W	PAN	PAYSON	Non-Fatal	Substantial	Airplane	N749PJ	AMERICAN CHAMPION AIRCRAFT	8GCBC	No	1.0	NaN	091	NaN	Personal	NaN	0.0	0.0	1.0	VMC	NaN	NaN	27-12-2022
88887	20221227106498	Accident	WPR23LA076	2022-12-26	Morgan, UT	United States	NaN	NaN	NaN	NaN	NaN	NaN	NaN	N210CU	CESSNA	210N	No	NaN	NaN	091	NaN	Personal	MC CESSNA 210N LLC	0.0	0.0	0.0	NaN	NaN	NaN	NaN
88888	20221230106513	Accident	ERA23LA097	2022-12-29	Athens, GA	United States	NaN	NaN	NaN	NaN	Minor	NaN	NaN	N9026P	PIPER	PA-24-260	No	NaN	NaN	091	NaN	Personal	NaN	0.0	1.0	1.0	NaN	NaN	NaN	30-12-2022

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts